Overview:
If you're still building formulas the old way - one cell at a time, you're missing out on one of Excel's most powerful modern features: dynamic arrays.
These game-changing formulas allow you to write one formula and instantly fill a whole range, saving time and reducing errors.
In this session, you'll learn what dynamic arrays are, how they differ from traditional formulas, and why they're a smarter, cleaner way to work with data. You'll see how functions like FILTER, UNIQUE, SORT, XLOOKUP, and SEQUENCE can simplify everything from data extraction to custom lists and lookup tasks, without resorting to clunky workarounds.
This is your chance to finally "think in arrays" and unlock a more intuitive, efficient way to build formulas in Excel. NOTE: Dynamic arrays are only available in Excel 365, 2021 and 2024
Why should you Attend:
Still dragging formulas across columns? Still using clunky workarounds? Dynamic arrays eliminate the complexity and tedium of old-school formula-building. If you're looking for a cleaner, faster, more flexible way to build reports, perform lookups, and manipulate data, this session will help you break out of the traditional formula mindset and take advantage of Excel's modern capabilities.
Areas Covered in the Session:
- What dynamic arrays are and how they work
- Key differences between dynamic arrays and legacy formulas
- How to write and troubleshoot dynamic array formulas
- Using FILTER, UNIQUE, and SORT to simplify data handling
- Replacing VLOOKUP with XLOOKUP for smarter lookups
- Creating custom sequences with SEQUENCE
- Real-world examples where dynamic arrays make life easier
- Limitations and things to watch out for when using dynamic arrays
Who Will Benefit:
- This session is ideal for intermediate Excel users who are comfortable with formulas but haven't yet embraced the new dynamic array approach
- It's especially relevant for:
- Analysts
- Admin Staff
- Finance Professionals
- Anyone who works with lists, lookups, or reporting in Excel
Instructor:
Mike Thomas - In a career spanning over 30 years, Mike Thomas, a UK-based IT Trainer, has delivered thousands of courses and produced hundreds of written and video-based tutorials.
He is a subject matter expert in a range of technologies on the Windows and Mac platforms however his primary focus and passion is Microsoft Office and Power BI.
Mike is a Microsoft MVP and a Fellow of The Learning and Performance Institute and has worked with and for many global and UK-based companies and organisations across a range of industries including healthcare, pharmaceutical and public sector.
In addition to training, he also designs and develops Microsoft Office-based solutions that automate key business tasks and processes